An Efficient Schema Transformation Technique for Data Migration from Relational to Column-Oriented Databases

Data transformation is the core process in migrating database from relational to NoSQL such as column-oriented database. However, there no standard guideline for data A number of schema techniques have been proposed improve and resulted better query processing time when compared time. these approaches produced redundant tables that turn consume large unnecessary storage size produce high due generated with column families transformed In this paper, an efficient technique proposed. The based on combination denormalization approach, access pattern multiple-nested schema. order validate work, implemented by transforming MySQL MongoDB benchmark also performed which are compared. Based experimental results, showed significant improvement terms space usage reduced